Fix Excel MAX returning zero for dates by converting text-based entries to valid serial numbers and handling empty ranges with IFERROR.